Viewing 15 posts - 1 through 15 (of 47 total)
Perhaps his MVP tag, superior knowledge and experience would help you change your mind...?
If you knew his real name and background, you might be keener to learn from him.
I can...
November 10, 2009 at 9:26 am
TheSQLGuru (11/9/2009)
If the statistics problems is because a bad clustered index choice, instead of doing recompiles every time, is not better if we avoid that problem changing the current index...
November 9, 2009 at 10:00 pm
You can disagree all you want, but you will be absolutely and indisputably wrong to do so. 🙂 Let me 'splain how this works: You have a...
November 9, 2009 at 7:26 pm
A plan which was optimal for one set of circumstances (parameter values) can be daft for a different set. RECOMPILE gives the optimizer a chance to produce a plan...
November 9, 2009 at 6:27 pm
The recompile option will force SQL to forget about the query plan and generates a new one each time the store procedure is gonna run. How that can improve the...
November 9, 2009 at 5:16 pm
Paul and guys ...
I can not run that sp again ... long history short, I am not authorized. And honestly, will generate similar execution plan. THe thing is , on...
November 8, 2009 at 6:06 pm
I know what you guys mean
This is the estimated, I did not run it myself. But I had the opportunity to see the sp in action and the information I...
November 7, 2009 at 1:16 pm
That's the real one 🙂 ... we ran that on dev environment and I captured that info ...
November 7, 2009 at 7:09 am
Thanks everyone for the hints.
did you folks have the chance to check the attached query plan? ... any suggestions? still I wonder why the sp takes 19hrs some days and...
November 6, 2009 at 1:24 pm
Why a composite and not three different Indexes? what could be the difference in terms of performance ... also, you mentioned MERGE could avoid non deterministic issues, can you elaborate...
November 6, 2009 at 10:16 am
Thanks Ken
If you have the chance to check the query plan later, please do.
I believe your Index creation code is the same I'm proposing, right? Three separate non clustered indexes...
November 6, 2009 at 10:01 am
GilaMonster (11/4/2009)
jocampo (11/4/2009)
Normally, when there is only one log file, if its missing, SQL will recreate it.
Sometimes, not always. If the DB was not cleanly shut down, the log...
November 4, 2009 at 2:48 pm
mohinidba (10/13/2009)
I have given data files location S:\mssql.1\mssql\sysdb in installaiton.
After installaiton i have cheked my system dbs are in S:\mssql.1\mssql\sysdb\........\data location.
I need to move my sysstem db to S:\mssql.1\mssql\sysdb.
can...
October 16, 2009 at 8:21 am
kevinH-1006814 (8/20/2009)
October 10, 2009 at 2:48 pm
You can use the same Windows Cluster but you will have to create another cluster group and inside that, put all the resources for your new application, including a new...
October 10, 2009 at 2:34 pm
Viewing 15 posts - 1 through 15 (of 47 total)